package manager.point;

import java.io.*;
import common.db.*;
import common.main.*;

public class PointSelectBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		//String id = (String)inputTable.get("id");
		
		queryBuffer = new StringBuffer("");	
		queryBuffer.append("UPDATE POINT SET USEYN='N'WHERE ID IN(SELECT ID FROM (SELECT ID, TRUNC(SYSDATE-(POINT_START_DATE+EXPERATION_DATE))FROM POINT WHERE SYSDATE-(POINT_START_DATE+EXPERATION_DATE)>'0'))");
				//queryBuffer.append("WHERE ID='"+id+"';");

		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}
